STEWARTSON & ASSOCIATES

Author

Joseph H

1 Intoduction

Hello, I’m Joseph from Morocco.

Inspired by Hans Rosling’s TED Talk, I taught myself data scraping, analysis, and visualization.
This non-academic approach has given me a unique perspective, as reflected in my projects—though it also means I may require a thorough onboarding process to align with team standards.

I’m open to starting as an intern, either full-time or part-time. Regarding time zones, I’m in UTC+1, but I’m flexible and can adjust my schedule to accommodate the team’s needs.

Feel free to reach me at joseph.ergo@proton.me, and to visit my website for more projects josephelhaddad.github.io.

This custom report, generated from processing 1.4 TB of public data locally, aims to explore the workforce dynamics of a company—up to 2020.
Essentially, I am doing research on a company that does research.

2 About the project

The project came to life after realizing that web scraping doesn’t allow deep-level filtering—without consuming too much time.The irony is, this project itself took me about a month, but the final RDB contains more data than I could ever scrape.

The raw data was 1.4 TB in size and holds information previously scraped.
Processing was done on my local machine using Python, Polars, and DuckDB, following this workflow:
- Processed raw data into structured Parquet files using Polars.
- Transformed each Parquet file into mini RDBs using Polars.
- Merged all mini RDBs into one using DuckDB.
- Analyzed and filtered data to fit the current project.

Alt text

3 EDA

3.1 human resources indestry’s yearly new recruit count

3.2 stewartson & associates’s workforce status over the years

4 Workforce sample

4.1 Ian Douglas

Job title: Research and resourcer
Associated: False
Socials: https://linkedin.com/in/stewartson | https://twitter.com/stewartson007 | https://linkedin.com/in/ian-douglas-1ba8b67

4.1.1 Ian Douglas’s working period at stewartson & associates

4.1.2 Gantt plot of Ian Douglas’s experience

4.2 Ian Morrison

Job title: Recruitment, resource management, workforce planning
Associated: True
Socials: https://linkedin.com/in/ianmorrisonfinservices | https://linkedin.com/in/ianmorrisonprocurementfinance | https://linkedin.com/in/ian-morrison-19906051 | https://linkedin.com/in/ianmorrisontravelfinance

4.2.1 Ian Morrison’s working period at stewartson & associates

4.2.2 Gantt plot of Ian Morrison’s experience

4.3 Ian Morrison

Job title: Research and resourcer
Associated: True
Socials: https://linkedin.com/in/stewartson

4.3.1 Ian Morrison’s working period at stewartson & associates

4.3.2 Gantt plot of Ian Morrison’s experience

4.4 Ian Morrison

Job title: Rpo auditor for rpoaudit, trading name for stewartson and associates
Associated: True
Socials: https://linkedin.com/in/ian-morrison-633a834a

4.4.1 Ian Morrison’s working period at stewartson & associates

4.4.2 Gantt plot of Ian Morrison’s experience

4.5 Ian Morrison

Job title: Principal
Associated: False
Socials: https://linkedin.com/in/crfhealthim | https://linkedin.com/in/ian-morrison-57b59144

4.5.1 Ian Morrison’s working period at stewartson & associates

4.5.2 Gantt plot of Ian Morrison’s experience

4.6 Nick Ryan

Job title: Senior recruitment consultant
Associated: True
Socials: https://linkedin.com/in/nick-ryan-95ba9980